Occurs after the result set has repositioned to a new row, BOF or EOF.
Private Sub object.RowCurrencyChange( )
The object placeholder represents an object expression that evaluates to an object in the Applies To list.
Remarks
This event is raised after the result set has repositioned to a new row, or has moved to either BOF or EOF. Any of the Move methods, the AbsolutePosition, PercentPosition, or Bookmark properties, or the Requery, MoreResults, or Update (after an AddNew) methods can also cause a the current row pointer to be repositioned and cause the RowCurrencyChange event to fire. The current position can be determined by accessing the AbsolutePosition, PercentPosition, or Bookmark properties of the object.
The RowCurrencyChange event can be used to execute a detail query when an associated master row currency changes. For example, if you setup a form containing a master customer record, and a set of rows corresponding to customer orders, you can use the RowCurrencyChange event to launch a query that returns all associated order information each time the user chooses another master customer record.
Note The order in which the RowCurrencyChange and Reposition events fire cannot be predicted.